UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mxh7O7iKp4mx5ija7hGMFqnR0wCM8ASrbiab61gcxvI='
WHERE
key_id = 'e1e29b8eeaf650413ddb134635f1f90d1da89caedc66e66a8ef16bd370afc659'
AND (
token = 'Mxh7O7iKp4mx5ija7hGMFqnR0wCM8ASrbiab61gcxvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)