SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '247eca55e8847df68e84831d67e1a9b0a0ce37de053d1d154c9ee5b316561659' 
  AND token = '39t1DGOJR4tRUWmiYNAm4+4KZD57J3pwSFAR6del4Qk=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00021

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}