SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '5008f8a831bf7e3aabf0e7e4f0335c2f8f7b300fd4cd97f97f14e447c7a35c39' 
  AND token = '0CCVsaYaiT6MCAJTit9301EqGVLJQ3nOjfvB9o8el5M=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00052

JSON explain

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