UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ca/fF4DHRSat55ybEMtZnMe/vBuVP7QRfesoK796y/A='
WHERE
key_id = '8696b9118ff8a7627eff3edb15d3a1865141c81ce1a05df4d8acf6dc37664fc4'
AND (
token = 'ca/fF4DHRSat55ybEMtZnMe/vBuVP7QRfesoK796y/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)