UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IMVYUq1tD5ROc95k2nZy7dFt7xInd9EbZPc+k7F6qTE=' 
WHERE 
  key_id = '96e21a6237c83b3af80cc92c9276b09d18d31cac63724bc2e8145634b17ecbf8' 
  AND (
    token = 'IMVYUq1tD5ROc95k2nZy7dFt7xInd9EbZPc+k7F6qTE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029