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