UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hLeVzKc9yTYptzr2P3uHRCn9v02FZUAN43eXnCkngtY='
WHERE
key_id = '1d0c268b26369f0a6e365972dbf82954324794546781a0eb77dc537103253457'
AND (
token = 'hLeVzKc9yTYptzr2P3uHRCn9v02FZUAN43eXnCkngtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)