UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g/Xtezg7m5W7aMWxzfEVRpVDl1v/s8sqxAPoM9K5YFs='
WHERE
key_id = '27d4ed40b247d6cca946431b8d0d92613252689cf0c5eea59942c63d6ab7a00e'
AND (
token = 'g/Xtezg7m5W7aMWxzfEVRpVDl1v/s8sqxAPoM9K5YFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)