UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q7zH9n3oHkmf8doAJSmo/PM6a/fYZIthzLyCo2boIkU='
WHERE
key_id = 'd017a4320de902057f10b98291ea0eda44222711f01fd921b4d120a16d26e20f'
AND (
token = 'Q7zH9n3oHkmf8doAJSmo/PM6a/fYZIthzLyCo2boIkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)