SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '413452f5770d4f92adbf5b81c8db3dcb0471a8128bb12bcfc52b6a18d99c26db' 
  AND token = 'q3Buyif8IOO0wn1cEYsVQFBzcV4ZK5BESwOtOZIm1Mw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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