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