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