UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5WhFfsb9qxo6jyyz2rT5B6y6AxPpEd8ENqd9T4mP0ZQ=' 
WHERE 
  key_id = '0868c8598e62ac258e86d053381b3b19f2d15e75d2ab2aba4d637c92a712f84e' 
  AND (
    token = '5WhFfsb9qxo6jyyz2rT5B6y6AxPpEd8ENqd9T4mP0ZQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034