UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZD9yfEDUSWmKrU4qQ5OO4UbafPCgR3FKAxP/DnFjOr8='
WHERE
key_id = 'b5606458d3b354c3eac53d57e01545456acf0477a73ea9b49785909c320b4b45'
AND (
token = 'ZD9yfEDUSWmKrU4qQ5OO4UbafPCgR3FKAxP/DnFjOr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)