UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's7M5B6yi6HaeuWjNDuoDkG3rH2TO1Dmf+Taxk2D+gIw='
WHERE
key_id = 'd1422465bbf346b795790edf72c58ca4a1a2b77e57430d3e5c36991104832957'
AND (
token = 's7M5B6yi6HaeuWjNDuoDkG3rH2TO1Dmf+Taxk2D+gIw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)