UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '29hSjCyK+H2ph39UqGtFZINtDdAKaZ97s3O9l9fwdKU='
WHERE
key_id = '8e3984731696893381d242a8cf973aa4be0056ebbe9876873e4920d95315ccb1'
AND (
token = '29hSjCyK+H2ph39UqGtFZINtDdAKaZ97s3O9l9fwdKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)