UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RH4t06iybjlWKlqDZb1c/YInfCf9LRln4YSj4AAmOhc='
WHERE
key_id = '1229d2d72bc20fbbfed249067c59f8b07f88d34c4728583ccb35f15e31faa8b2'
AND (
token = 'RH4t06iybjlWKlqDZb1c/YInfCf9LRln4YSj4AAmOhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)