UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pkiHTbQElKj5O+7HMzkLo60/sCVOEXPXm2iqehldujE='
WHERE
key_id = '78e1ee1d7cfb1fc4459cf03de2092d53d1e3ad31f54adfbc445b63d44d67f7ba'
AND (
token = 'pkiHTbQElKj5O+7HMzkLo60/sCVOEXPXm2iqehldujE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)