SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '52fb2dcefc0a30da0e8b4d2aa7c5bb5659ee9f40092ce7540faef9a18320e15a' 
  AND token = 'HPZn30/24ejrwlofeWq47QMsyv/I8W15Wet/k8TC4ZI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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