SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'b0efe8fe03754dae1811fb4c4a386692a2ef34eb282b62209c9c556a9df9dc12' 
  AND token = '+lRQ/Hif9gbRIdbG+zBhfEn5LMYi5R1Kjaw0gqCF/tQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00028

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}