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