SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'eddd8f15a9468ba3533cbe26eb3c9a97d6a0a3e5189b5e779ea1ef39771b879e' 
  AND token = 'H2FaUtRVOOzL5o9M/uiFu6Tf90O0q4GDRV900ZtMsD8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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