SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'a0c774fa4e8b48a7b71270a6e8974f569269323d670cf9d7901cf9d0f5a80644' 
  AND token = 'CIc3q2pSqHsaHcOMMJofUrY9O1zSYwvRNZwxckvPWoA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00029

JSON explain

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