UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ZaYZQYqj9PD2KLm6T6hKK6EyGKRVFeTXw2qyIIAIQI='
WHERE
key_id = '3bbc7c9798b43123cfab4fa6a8670e03d0adc12bee8baab444b4e92c68b54ea3'
AND (
token = '8ZaYZQYqj9PD2KLm6T6hKK6EyGKRVFeTXw2qyIIAIQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)