SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '7d55d0838717d0e500b67d1298202246eaa483b17e7d1dafd87f3412e9578175' 
  AND token = '+km/QLWt4Afogi1ethC1kT6/K4PSxJzOOb9TQqQvzig=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00026

JSON explain

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