UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bTBQbES7ox3tHVERBSkM6Pyxy733UakBLPU98Z0XL5k='
WHERE
key_id = '4229643c5117fd1a2976ce88f34f630cd67fad9d68c2acf8e049d1e1e3257da9'
AND (
token = 'bTBQbES7ox3tHVERBSkM6Pyxy733UakBLPU98Z0XL5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)