UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pmjp/CnarceCVSMmwB74WMK3W2vFCXns8E64fNUmXqo='
WHERE
key_id = 'ffe829ee0e8717484b299376491802f353ac77a0ada4b3db859c6e023b2659bc'
AND (
token = 'pmjp/CnarceCVSMmwB74WMK3W2vFCXns8E64fNUmXqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)