SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'bbe06d7b7e520dd7eabf677386239df4dff61bda0f527c414bbcdc2cd6e6e1be' 
  AND token = 'Qt9DiILLFckf+1BDahr06h+GaRWoO6U8Bqe5UlDsDnU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00025

JSON explain

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