UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKvk9M9rztgCvUvfW5X8Mc2jq1YRb6Mhl6DyMRd/qTA='
WHERE
key_id = 'fcfd4eecec408589ba077c5d8783c5fea4b3756ab4620a2b7e7c904a7832c813'
AND (
token = 'zKvk9M9rztgCvUvfW5X8Mc2jq1YRb6Mhl6DyMRd/qTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)