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