UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZW00vUwpTjB4kvEeuY3wd3O6pTmUNJ03S08VveIeAY='
WHERE
key_id = '11f8e9553affc087b7f759914def109ac6b70883e2ac3d8a29c37e49d6e18a1e'
AND (
token = 'XZW00vUwpTjB4kvEeuY3wd3O6pTmUNJ03S08VveIeAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)