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