UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YzL9AKRfKbFn933ABPwIKa0LGQFlDJeNhoFADrgqfYk='
WHERE
key_id = 'f616ad0f658fac75acdea402ddb069c27b3c04dbcc7c782810c5c5cea58696a6'
AND (
token = 'YzL9AKRfKbFn933ABPwIKa0LGQFlDJeNhoFADrgqfYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)