UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wTHknFiI7HbrX5foX8AXo+NmPisWAwKDgyVqCK98xcI='
WHERE
key_id = '657f14cfcf7b8f8cb64ea2c1d385bc019959bfb431ad6cf5151d08b64acc7a5b'
AND (
token = 'wTHknFiI7HbrX5foX8AXo+NmPisWAwKDgyVqCK98xcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)