UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sip7oKEBj6mBnOIDSMQC1eZKHXYn+vXuEfrvbt5hNMg='
WHERE
key_id = '77e5915a5a9431ff4c686a2efda1f8c5f83bdd4f6f4bb16a26268b149ad8e1ca'
AND (
token = 'Sip7oKEBj6mBnOIDSMQC1eZKHXYn+vXuEfrvbt5hNMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)