UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'er7bFXCD8SuGSnCzFLSzmqLsT8KE+46qdMN+vO3nzK4='
WHERE
key_id = 'eae3b1ac6327c46966cc176e72be7e257fa1dc11b2b0a9a79d736177e88c0cdc'
AND (
token = 'er7bFXCD8SuGSnCzFLSzmqLsT8KE+46qdMN+vO3nzK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)