UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'caW/UI/4hsPKArjzBj4KyAUgWiX00SpX3E+csOoXS6w='
WHERE
key_id = '807af507c10f101181ed94e9a6c220ce700ff6f72ef7b42b5deda52e91f0f9b5'
AND (
token = 'caW/UI/4hsPKArjzBj4KyAUgWiX00SpX3E+csOoXS6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)