UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hGJ8CNL5j0JEX5b++medRrFCPAWm+FIxL/4e6l2fq8M='
WHERE
key_id = 'f74d7e38add54745dd6c65716b67dc700dcfa735cdbec8acae07714cdc37de25'
AND (
token = 'hGJ8CNL5j0JEX5b++medRrFCPAWm+FIxL/4e6l2fq8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)